IF EXISTS (SELECT * from dbo.sysobjects WHERE id = object_id(N'[dbo].[SelectProductoByIdLinea]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[SelectProductoByIdLinea]
GO

CREATE PROCEDURE [dbo].[SelectProductoByIdLinea]
(
	@IdLinea int
)
AS
BEGIN
	SET NOCOUNT ON

	SELECT
	[IdProducto],
	[Nombre],
	[Descripcion],
	[IdLinea],
	[Icono],
	[Imagen],
	[Estado]
	FROM [Producto]
	WHERE [IdLinea] = @IdLinea

	SET NOCOUNT OFF
END

GO
